Chapter 2-4: Files and Fields

Token Fields Token Table

token table accesses the Token Table overlay, shown below. A token table provides an alternative to the use of range checks for data token.

Token Fields Token Table Overlay

You can establish a token table for any Token field in the data dictionary. The entries in the table are case-sensitive. If you enter a token value in all capital letters, an application user must enter the value in all capital letters.

Token table operations are database-independent. They access a designer-defined table in application design, not data contained in a file in a database, for the range of possible values. As a result, token does not vary from database to database. It is automatically available to, and exactly the same for, every database that is associated with an application.

The Token Table overlay contains the following fields:

Token Value is the alphanumeric value associated with the token ID. APPX automatically translates between token values and ID's whenever necessary. This entry is case-sensitive. If entered in capital letters, an application user must also enter the value in capital letters.

ID displays a unique number that is defaulted by APPX. This specification establishes the binary value that APPX stores in place of the associated token value. APPXassigns the first token value an ID of 1, with additional values assigned an ID that is equal to the highest existing ID plus 1. The default can be overridden, but must be unique within a table. APPX does not require that ID's be contiguous within a table.

Application Design Manual                                         "Powered by Appx Software"

1029

©2006 By APPX Software, Inc. All Rights Reserved